package DB;

/**
 *
 * @author pgrabin
 */
public abstract class Views {

    public static final String dropViewInscricao = "drop view if exists viewInscricao";
    public static final String createViewInscricao = 
            "CREATE VIEW IF NOT EXISTS viewInscricao AS"
            + "       SELECT i.id,"
            + "              e.nome,"
            + "              u.nome,"
            + "              i.dataInscricao"
            + "         FROM inscricoes i, "
            + "              eventos e, "
            + "              usuarios u"
            + "        WHERE i.idEvento = e.id "
            + "              AND"
            + "              i.idParticipante = u.id;";
}
